This Expert appears when you choose the Top N/Sort Group Expert command from the Report menu.
Use the Top N/Sort Group Expert to identify "top" groups (the best sales representatives in a sales report, the biggest customers in an order report, the states with the most customers in a customer report, and so on).
Use the Top N/Sort Group Expert to sort all of the records in a report or just the top or bottom groups of records. Depending on which option you choose the Expert appears with different options.
Use this list to choose one of the following sorting options for your Top group:
This list displays a list of summary fields in your report. Select the field you want to select Top N or Bottom N values for from this list. When Sort All groups is selected, use the scroll box below the based on list to see the fields chosen for sorting.
Enter the number of Top N or Bottom N values (where N is the number of values) you want to select into this edit box.
Select this option if you want to include all fields that do not fit into your Top N or Bottom N selection under a specified group name. Enter the group name you want all fields that do not fit into your Top N or Bottom N selection to appear under.
Click this button to delete the selected summary field. This is only available when Sort All Groups is selected.
Select the Ascending option to sort the fields in ascending (A to Z, 1 to 9) order.
Select the Descending option to sort the fields in descending (Z to A, 9 to 1) order.
Sorting, Grouping, and Totaling
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |